Linda Manduchova ✭✭✭✭

Overview

Overview

Email	linda.white17@optum.com
Roles	Member
Badges	26

About Me

About Me

Linkedin	https://www.linkedin.com/in/linda-white-mba-a98b93149/

Analytics

27

Posts

121

Visits

2.8k

Points

Jan 14, 2022

Join Date

Jan 8, 2025

Last Active

Reactions

• Vote Up 2

  2
• Awesome 9

  9

• Activity
• Discussions
• Comments27

• Re: Convert numbers into dates for this CY

  Linda Manduchova

  02/15/24
  Hi @jmoss1073 - Try the following formula where the "Number Field" column is the one where you store the numbers (in your given example 366). =[Number Field]@row + DATE(2023, 12, 31) Linda
  1 ·

• Re: Can I use the Substitute function to remove a line-break?

  Linda Manduchova

  02/15/24
  Hello @Meredith Rhodes - You can try the following formula, however, if you have multiple line-breaks, the formula will return multiple semicolons. =SUBSTITUTE(Name@row, CHAR(10), "; ") Lin…
  1 ·

• Re: Return a value from a cell based on today's date

  Linda Manduchova

  02/06/24
  Hi @David Bouchard I would recommend to use the following cell formulas for the respective columns: Total Running Hours: =SUMIF(Date:Date, <TODAY(), [Duration (Hrs)]:[Duration (Hrs)]) Total Runnin…
  1 ·

Previous